/********************************************************************
  Copyright by PCI, 2002-10-08
  File Name: db_ppm_mkt_resource.cxx
  Created Date: 2002-10-08 
  Author: Machine
  Version: 1.0 
  Last Version Date: 
  Version Date:
*******************************************************************/
/********************************************************************
  Copyright by PCI, 2002-10-08
  Class Name: CTable_PPM_MKT_RESOURCE
  Created Date: 2002-10-08 
  Author: Machine
  Defined File: db_ppm_mkt_resource.hxx
  Last Version Date: 
  Version Date:
*******************************************************************/
#include "table_ppm.h"

CTable_PPM_MKT_RESOURCE::CTable_PPM_MKT_RESOURCE( )
 :NPCRecordSet( )
{
  setTableName( "PPM_MKT_RESOURCE" );
  prepareTable();
  prepareQuery();
 
  MKT_RES_CD.setField( "MKT_RES_CD", DATA_DOUBLE, 22, 1 );
  makeTableItem( MKT_RES_CD );
  makeKeyItem( MKT_RES_CD ); 
  MKT_RES_TYPE_CD.setField( "MKT_RES_TYPE_CD", DATA_DOUBLE, 22, 2 );
  makeTableItem( MKT_RES_TYPE_CD );
  makeKeyItem( MKT_RES_TYPE_CD ); 
  MKT_RES_NAME.setField( "MKT_RES_NAME", DATA_CHAR, 256, 0 );
  makeTableItem( MKT_RES_NAME );
  MKT_RES_DESC.setField( "MKT_RES_DESC", DATA_CHAR, 4000, 0 );
  makeTableItem( MKT_RES_DESC );
  INSTANCE_FLAG.setField( "INSTANCE_FLAG", DATA_CHAR, 1, 0 );
  makeTableItem( INSTANCE_FLAG );
  STANDARD_CD.setField( "STANDARD_CD", DATA_DOUBLE, 22, 0 );
  makeTableItem( STANDARD_CD );
  CREATE_DATE.setField("CREATE_DATE", DATA_DATETIME , 7, 0);
  makeTableItem(CREATE_DATE);
  STATE_DATE.setField("STATE_DATE", DATA_DATETIME , 7, 0);
  makeTableItem(STATE_DATE);
  STATE.setField( "STATE", DATA_CHAR, 20, 0 );
  makeTableItem( STATE );
  OBJ_TYPE.setField( "OBJ_TYPE", DATA_CHAR, 20, 0 );
  makeTableItem( OBJ_TYPE );
  PROCESS_TYPE.setField( "PROCESS_TYPE", DATA_CHAR, 20, 0 );
  makeTableItem( PROCESS_TYPE );
  EFF_FLAG.setField( "EFF_FLAG", DATA_CHAR, 3, 0 );
  makeTableItem( EFF_FLAG );
}


CTable_PPM_MKT_RESOURCE::CTable_PPM_MKT_RESOURCE( NPConnection& pcldb )
 :NPCRecordSet( pcldb )
{
  setTableName( "PPM_MKT_RESOURCE" );
  prepareTable();
  prepareQuery();
 
  MKT_RES_CD.setField( "MKT_RES_CD", DATA_DOUBLE, 22, 1 );
  makeTableItem( MKT_RES_CD );
  makeKeyItem( MKT_RES_CD ); 
  MKT_RES_TYPE_CD.setField( "MKT_RES_TYPE_CD", DATA_DOUBLE, 22, 2 );
  makeTableItem( MKT_RES_TYPE_CD );
  makeKeyItem( MKT_RES_TYPE_CD ); 
  MKT_RES_NAME.setField( "MKT_RES_NAME", DATA_CHAR, 256, 0 );
  makeTableItem( MKT_RES_NAME );
  MKT_RES_DESC.setField( "MKT_RES_DESC", DATA_CHAR, 4000, 0 );
  makeTableItem( MKT_RES_DESC );
  INSTANCE_FLAG.setField( "INSTANCE_FLAG", DATA_CHAR, 1, 0 );
  makeTableItem( INSTANCE_FLAG );
  STANDARD_CD.setField( "STANDARD_CD", DATA_DOUBLE, 22, 0 );
  makeTableItem( STANDARD_CD );
  CREATE_DATE.setField("CREATE_DATE", DATA_DATETIME , 7, 0);
  makeTableItem(CREATE_DATE);
  STATE_DATE.setField("STATE_DATE", DATA_DATETIME , 7, 0);
  makeTableItem(STATE_DATE);
  STATE.setField( "STATE", DATA_CHAR, 20, 0 );
  makeTableItem( STATE );
  OBJ_TYPE.setField( "OBJ_TYPE", DATA_CHAR, 20, 0 );
  makeTableItem( OBJ_TYPE );
  PROCESS_TYPE.setField( "PROCESS_TYPE", DATA_CHAR, 20, 0 );
  makeTableItem( PROCESS_TYPE );
  EFF_FLAG.setField( "EFF_FLAG", DATA_CHAR, 3, 0 );
  makeTableItem( EFF_FLAG );
}

CTable_PPM_MKT_RESOURCE::~CTable_PPM_MKT_RESOURCE( )
{
    close();
}

